﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CustomerDataSet" targetNamespace="http://tempuri.org/CustomerDataSet.xsd" xmlns:mstns="http://tempuri.org/CustomerDataSet.xsd" xmlns="http://tempuri.org/CustomerDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection ConnectionStringObject="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\dbInternetSales1.accdb;Persist Security Info=True;Jet OLEDB:Database Password=Bertha1325" IsAppSettingsProperty="false" Modifier="Assembly" Name="dbInternetSales1.accdb" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerTableAdapter" GeneratorDataComponentClassName="CustomerTableAdapter" Name="Customer" UserDataComponentName="CustomerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Customer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID, FirstName, LastName, StartDate, UserName, Phone, CellPhone, Email, Street, City, State, Zip, Notes
FROM            Customer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="CellPhone" DataSetColumn="CellPhone" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Street" DataSetColumn="Street" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="Zip" DataSetColumn="Zip" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Customer" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDomainName" GetMethodModifier="Public" GetMethodName="GetDataByDomainName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDomainName" UserSourceName="GetDataByDomainName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT top 1 Customer.CellPhone, Customer.City, Customer.Email, Customer.FirstName, Customer.ID, Customer.LastName, Customer.Notes, Customer.Phone, Customer.StartDate, Customer.State, Customer.Street, Customer.UserName, Customer.Zip FROM (Customer INNER JOIN Locations ON Customer.ID = Locations.CustomerID) WHERE (Locations.DomainName=? )</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="DomainName" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="DomainName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="DomainName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Customer" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLastName" GetMethodModifier="Public" GetMethodName="GetDataByLastName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLastName" UserSourceName="GetDataByLastName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CellPhone, City, Email, FirstName, ID, LastName, Notes, Phone, StartDate, State, Street, UserName, Zip FROM Customer WHERE (LastName = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LastName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LastName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Customer" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserName" GetMethodModifier="Public" GetMethodName="GetDataByUserName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserName" UserSourceName="GetDataByUserName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CellPhone, City, Email, FirstName, ID, LastName, Notes, Phone, StartDate, State, Street, UserName, Zip FROM Customer WHERE (UserName = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="UserName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="UserName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Customer" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUsernameAndLastName" GetMethodModifier="Public" GetMethodName="GetDataByUsernameAndLastName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUsernameAndLastName" UserSourceName="GetDataByUsernameAndLastName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID, FirstName, LastName, StartDate, UserName, Phone, CellPhone, Email, Street, City, State, Zip, Notes
FROM            Customer
WHERE        (LastName = ?) AND (UserName = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LastName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LastName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="UserName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="UserName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertNewCustomer" Modifier="Public" Name="InsertNewCustomer" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertNewCustomer">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Customer
                         (FirstName, LastName, StartDate, UserName, Phone, CellPhone, Email, Street, City, State, Zip, Notes)
VALUES        (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="FirstName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="FirstName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="LastName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LastName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="StartDate" DataSourceName="Customer" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="UserName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="UserName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="Phone" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Phone" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="CellPhone" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="CellPhone" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="CellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="Email" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="Street" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Street" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="City" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="State" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="State" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="Zip" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Zip" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param12" ColumnName="Notes" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateCustomer" Modifier="Public" Name="UpdateCustomer" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateCustomer">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       Customer
SET                FirstName = ?, LastName = ?, StartDate = ?, UserName = ?, Phone = ?, CellPhone = ?, Email = ?, Street = ?, City = ?, State = ?, Notes = ?, Zip = ?
WHERE        (ID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="FirstName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="FirstName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="LastName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LastName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="StartDate" DataSourceName="Customer" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="UserName" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="UserName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="Phone" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Phone" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="CellPhone" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="CellPhone" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="CellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="Email" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="Street" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Street" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="City" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="State" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="State" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="Notes" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param12" ColumnName="Zip" DataSourceName="Customer" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Zip" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param13" ColumnName="ID" DataSourceName="Customer" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LocationsTableAdapter" GeneratorDataComponentClassName="LocationsTableAdapter" Name="Locations" UserDataComponentName="LocationsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Locations" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Locations` WHERE ((`UID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Locations` (`UID`, `CustomerID`, `Phone`, `KeyPhrase`, `DomainName`, `PageTitle`, `PageDescript`, `Street`, `City`, `Zip`, `CustWebsite`, `CompanyName`, `StartDate`, `Terms`, `Notes`, `State`, `Image`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="KeyPhrase" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="KeyPhrase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DomainName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DomainName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PageTitle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PageTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PageDescript" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PageDescript" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Street" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Zip" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustWebsite" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustWebsite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CompanyName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Terms" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Terms" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="State" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     ID, UID, CustomerID, Phone, KeyPhrase, DomainName, PageTitle, PageDescript, Street, City, Zip, CustWebsite, CompanyName, StartDate, Terms, Notes, State, 
                      [Image]
FROM         Locations</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Locations` SET `UID` = ?, `CustomerID` = ?, `Phone` = ?, `KeyPhrase` = ?, `DomainName` = ?, `PageTitle` = ?, `PageDescript` = ?, `Street` = ?, `City` = ?, `Zip` = ?, `CustWebsite` = ?, `CompanyName` = ?, `StartDate` = ?, `Terms` = ?, `Notes` = ?, `State` = ?, `Image` = ? WHERE ((`UID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="KeyPhrase" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="KeyPhrase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DomainName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DomainName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PageTitle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PageTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PageDescript" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PageDescript" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Street" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Zip" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CustWebsite" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CustWebsite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CompanyName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Terms" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Terms" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="State" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="KeyPhrase" DataSetColumn="KeyPhrase" />
              <Mapping SourceColumn="DomainName" DataSetColumn="DomainName" />
              <Mapping SourceColumn="PageTitle" DataSetColumn="PageTitle" />
              <Mapping SourceColumn="PageDescript" DataSetColumn="PageDescript" />
              <Mapping SourceColumn="Street" DataSetColumn="Street" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="Zip" DataSetColumn="Zip" />
              <Mapping SourceColumn="CustWebsite" DataSetColumn="CustWebsite" />
              <Mapping SourceColumn="CompanyName" DataSetColumn="CompanyName" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="Terms" DataSetColumn="Terms" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="UID" DataSetColumn="UID" />
              <Mapping SourceColumn="Image" DataSetColumn="Image" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Locations" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCustomerID" GetMethodModifier="Public" GetMethodName="GetDataByCustomerID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCustomerID" UserSourceName="GetDataByCustomerID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT City, CompanyName, CustWebsite, CustomerID, DomainName, ID, [Image], KeyPhrase, Notes, PageDescript, PageTitle, Phone, StartDate, State, Street, Terms, UID, Zip FROM Locations WHERE (CustomerID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="CustomerID" DataSourceName="Locations" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Locations" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLocationUID" GetMethodModifier="Public" GetMethodName="GetDataByLocationUID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLocationUID" UserSourceName="GetDataByLocationUID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     ID, UID, CustomerID, Phone, KeyPhrase, DomainName, PageTitle, PageDescript, Street, City, Zip, CustWebsite, CompanyName, StartDate, Terms, Notes, State, 
                      [Image]
FROM         Locations
WHERE     (UID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="UID" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="UID" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertNewLocation" Modifier="Public" Name="InsertNewLocation" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertNewLocation">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Locations
                      (CustomerID, Phone, KeyPhrase, DomainName, PageTitle, PageDescript, Street, City, Zip, CustWebsite, CompanyName, StartDate, Terms, Notes, State, UID, [Image])
VALUES     (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="CustomerID" DataSourceName="Locations" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="CustomerID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Phone" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Phone" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="KeyPhrase" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="KeyPhrase" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="KeyPhrase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="DomainName" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="DomainName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="DomainName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="PageTitle" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="PageTitle" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="PageTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="PageDescript" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="PageDescript" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="PageDescript" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="Street" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Street" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="City" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="Zip" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Zip" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="CustWebsite" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="CustWebsite" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="CustWebsite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="CompanyName" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="CompanyName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param12" ColumnName="StartDate" DataSourceName="Locations" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="StartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param13" ColumnName="Terms" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Terms" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Terms" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param14" ColumnName="Notes" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param15" ColumnName="State" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="State" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param16" ColumnName="UID" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="UID" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param17" ColumnName="Image" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Image" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateLocationsDetail" Modifier="Public" Name="UpdateLocationsDetail" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateLocationsDetail">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE `Locations` SET `Phone` = ?, `KeyPhrase` = ?, `DomainName` = ?, `PageTitle` = ?, `PageDescript` = ?, `Street` = ?, `City` = ?, `Zip` = ?, `CustWebsite` = ?, `CompanyName` = ?,  `Terms` = ?, `Notes` = ?, `State` = ?, `Image` = ? WHERE ((`UID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Phone" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Phone" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="KeyPhrase" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="KeyPhrase" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="KeyPhrase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="DomainName" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="DomainName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="DomainName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="PageTitle" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="PageTitle" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="PageTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="PageDescript" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="PageDescript" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="PageDescript" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="Street" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Street" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="City" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="City" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="Zip" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Zip" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Zip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="CustWebsite" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="CustWebsite" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="CustWebsite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="CompanyName" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="CompanyName" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="Terms" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Terms" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Terms" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param12" ColumnName="Notes" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Notes" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param13" ColumnName="State" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="State" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param14" ColumnName="Image" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Image" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param15" ColumnName="UID" DataSourceName="Locations" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Original_UID" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImagesTableAdapter" GeneratorDataComponentClassName="ImagesTableAdapter" Name="Images" UserDataComponentName="ImagesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Images" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Images` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Images` (`LocationsUID`, `Image1`, `Image1Data`, `Image2`, `Image2Data`, `Image3`, `Image3Data`, `Image4`, `Image4Data`, `Image5`, `Image5Data`, `Image6`, `Image6Data`, `ImageLocation`, `ImageData`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image1Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image1Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image2Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image2Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image3Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image3Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image4Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image4Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image5" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image5Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image5Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image6" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image6Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image6Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ImageLocation" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImageLocation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ImageData" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImageData" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     ID, LocationsUID, Image1, Image1Data, Image2, Image2Data, Image3, Image3Data, Image4, Image4Data, Image5, Image5Data, Image6, Image6Data, ImageLocation, 
                      ImageData
FROM         Images</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Images` SET `LocationsUID` = ?, `Image1` = ?, `Image1Data` = ?, `Image2` = ?, `Image2Data` = ?, `Image3` = ?, `Image3Data` = ?, `Image4` = ?, `Image4Data` = ?, `Image5` = ?, `Image5Data` = ?, `Image6` = ?, `Image6Data` = ?, `ImageLocation` = ?, `ImageData` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image1Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image1Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image2Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image2Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image3Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image3Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image4Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image4Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image5" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image5Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image5Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image6" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image6Data" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image6Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ImageLocation" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImageLocation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ImageData" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImageData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Image1" DataSetColumn="Image1" />
              <Mapping SourceColumn="Image1Data" DataSetColumn="Image1Data" />
              <Mapping SourceColumn="Image2" DataSetColumn="Image2" />
              <Mapping SourceColumn="Image2Data" DataSetColumn="Image2Data" />
              <Mapping SourceColumn="Image3" DataSetColumn="Image3" />
              <Mapping SourceColumn="Image3Data" DataSetColumn="Image3Data" />
              <Mapping SourceColumn="Image4" DataSetColumn="Image4" />
              <Mapping SourceColumn="Image4Data" DataSetColumn="Image4Data" />
              <Mapping SourceColumn="Image5" DataSetColumn="Image5" />
              <Mapping SourceColumn="Image5Data" DataSetColumn="Image5Data" />
              <Mapping SourceColumn="Image6" DataSetColumn="Image6" />
              <Mapping SourceColumn="Image6Data" DataSetColumn="Image6Data" />
              <Mapping SourceColumn="LocationsUID" DataSetColumn="LocationsUID" />
              <Mapping SourceColumn="ImageLocation" DataSetColumn="ImageLocation" />
              <Mapping SourceColumn="ImageData" DataSetColumn="ImageData" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Images" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLocationsUID" GetMethodModifier="Public" GetMethodName="GetDataByLocationsUID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLocationsUID" UserSourceName="GetDataByLocationsUID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Image1, Image1Data, Image2, Image2Data, Image3, Image3Data, Image4, Image4Data, Image5, Image5Data, Image6, Image6Data, ImageData, ImageLocation, LocationsUID FROM Images WHERE (LocationsUID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LocationsUID" DataSourceName="Images" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertNewImage" Modifier="Public" Name="InsertNewImage" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertNewImage">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Images
                      (LocationsUID, ImageData, ImageLocation)
VALUES     (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="LocationsUID" DataSourceName="Images" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="ImageData" DataSourceName="Images" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="ImageData" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="ImageData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="ImageLocation" DataSourceName="Images" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="ImageLocation" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="ImageLocation" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateImageDetails" Modifier="Public" Name="UpdateImageDetails" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateImageDetails">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE `Images` SET `ImageLocation` = ?, `ImageData` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="ImageLocation" DataSourceName="Images" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="ImageLocation" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="ImageLocation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="ImageData" DataSourceName="Images" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="ImageData" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="ImageData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param3" ColumnName="ID" DataSourceName="Images" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReasonsTableAdapter" GeneratorDataComponentClassName="ReasonsTableAdapter" Name="Reasons" UserDataComponentName="ReasonsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Reasons" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Reasons` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Reasons` (`LocationsUID`, `Reason1`, `Reason2`, `Reason3`, `Reason4`, `Reason5`, `Reason6`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason5" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason6" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason6" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, LocationsUID, Reason1, Reason2, Reason3, Reason4, Reason5, Reason6 FROM Reasons</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Reasons` SET `LocationsUID` = ?, `Reason1` = ?, `Reason2` = ?, `Reason3` = ?, `Reason4` = ?, `Reason5` = ?, `Reason6` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason5" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reason6" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reason6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Reason1" DataSetColumn="Reason1" />
              <Mapping SourceColumn="Reason2" DataSetColumn="Reason2" />
              <Mapping SourceColumn="Reason3" DataSetColumn="Reason3" />
              <Mapping SourceColumn="Reason4" DataSetColumn="Reason4" />
              <Mapping SourceColumn="Reason5" DataSetColumn="Reason5" />
              <Mapping SourceColumn="Reason6" DataSetColumn="Reason6" />
              <Mapping SourceColumn="LocationsUID" DataSetColumn="LocationsUID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Reasons" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLocationsUID" GetMethodModifier="Public" GetMethodName="GetDataByLocationsUID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLocationsUID" UserSourceName="GetDataByLocationsUID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     ID, LocationsUID, Reason1, Reason2, Reason3, Reason4, Reason5, Reason6
FROM         Reasons
WHERE     (LocationsUID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LocationsUID" DataSourceName="Reasons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertReason" Modifier="Public" Name="InsertReason" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertReason">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO `Reasons` (`LocationsUID`, `Reason1`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LocationsUID" DataSourceName="Reasons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Reason1" DataSourceName="Reasons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Reason1" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Reason1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateReason" Modifier="Public" Name="UpdateReason" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateReason">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE `Reasons` SET `Reason1` = ?  WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Reason1" DataSourceName="Reasons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Reason1" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Reason1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="ID" DataSourceName="Reasons" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CouponsTableAdapter" GeneratorDataComponentClassName="CouponsTableAdapter" Name="Coupons" UserDataComponentName="CouponsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Coupons" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Coupons` WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Coupons` (`LocationsUID`, `Headline`, `SubHeadline`, `Description`, `Image`, `Color`, `Printable`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Headline" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Headline" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SubHeadline" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SubHeadline" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Color" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Printable" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Printable" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Coupons.*
FROM         Coupons</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Coupons` SET `LocationsUID` = ?, `Headline` = ?, `SubHeadline` = ?, `Description` = ?, `Image` = ?, `Color` = ?, `Printable` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Headline" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Headline" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SubHeadline" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SubHeadline" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Image" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Color" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Printable" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Printable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="LocationsUID" DataSetColumn="LocationsUID" />
              <Mapping SourceColumn="Headline" DataSetColumn="Headline" />
              <Mapping SourceColumn="SubHeadline" DataSetColumn="SubHeadline" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Image" DataSetColumn="Image" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
              <Mapping SourceColumn="Printable" DataSetColumn="Printable" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="Coupons" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLocationUID" GetMethodModifier="Public" GetMethodName="GetDataByLocationUID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLocationUID" UserSourceName="GetDataByLocationUID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     ID, LocationsUID, Headline, SubHeadline, Description, [Image], Color, Printable
FROM         Coupons
WHERE     (LocationsUID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LocationsUID" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertNewCoupon" Modifier="Public" Name="InsertNewCoupon" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertNewCoupon">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO `Coupons` (`LocationsUID`, `Headline`, `SubHeadline`, `Description`, `Image`, `Color`, `Printable`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LocationsUID" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="LocationsUID" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="LocationsUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Headline" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Headline" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Headline" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="SubHeadline" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="SubHeadline" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="SubHeadline" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="Description" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="Image" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Image" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="Color" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Color" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param7" ColumnName="Printable" DataSourceName="Coupons" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="Printable" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="Printable" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="dbInternetSales1.accdb" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateCouponDetails" Modifier="Public" Name="UpdateCouponDetails" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateCouponDetails">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE `Coupons` SET `Headline` = ?, `SubHeadline` = ?, `Description` = ?, `Image` = ?, `Color` = ?, `Printable` = ? WHERE ((`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Headline" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Headline" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Headline" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="SubHeadline" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="SubHeadline" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="SubHeadline" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Description" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="Image" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Image" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="Color" DataSourceName="Coupons" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Color" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param6" ColumnName="Printable" DataSourceName="Coupons" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="Printable" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="Printable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param7" ColumnName="ID" DataSourceName="Coupons" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CustomerDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CustomerDataSet" msprop:Generator_UserDSName="CustomerDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Customer" msprop:Generator_TableClassName="CustomerDataTable" msprop:Generator_TableVarName="tableCustomer" msprop:Generator_TablePropName="Customer" msprop:Generator_RowDeletingName="CustomerRowDeleting" msprop:Generator_UserTableName="Customer" msprop:Generator_RowChangingName="CustomerRowChanging" msprop:Generator_RowEvHandlerName="CustomerRowChangeEventHandler" msprop:Generator_RowDeletedName="CustomerRowDeleted" msprop:Generator_RowEvArgName="CustomerRowChangeEvent" msprop:Generator_RowChangedName="CustomerRowChanged" msprop:Generator_RowClassName="CustomerRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CellPhone" msprop:Generator_ColumnVarNameInTable="columnCellPhone" msprop:Generator_ColumnPropNameInRow="CellPhone" msprop:Generator_ColumnPropNameInTable="CellPhoneColumn" msprop:Generator_UserColumnName="CellPhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Street" msprop:Generator_ColumnVarNameInTable="columnStreet" msprop:Generator_ColumnPropNameInRow="Street" msprop:Generator_ColumnPropNameInTable="StreetColumn" msprop:Generator_UserColumnName="Street" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Zip" msprop:Generator_ColumnVarNameInTable="columnZip" msprop:Generator_ColumnPropNameInRow="Zip" msprop:Generator_ColumnPropNameInTable="ZipColumn" msprop:Generator_UserColumnName="Zip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnPropNameInTable="NotesColumn" msprop:Generator_UserColumnName="Notes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Locations" msprop:Generator_TableClassName="LocationsDataTable" msprop:Generator_TableVarName="tableLocations" msprop:Generator_TablePropName="Locations" msprop:Generator_RowDeletingName="LocationsRowDeleting" msprop:Generator_UserTableName="Locations" msprop:Generator_RowChangingName="LocationsRowChanging" msprop:Generator_RowEvHandlerName="LocationsRowChangeEventHandler" msprop:Generator_RowDeletedName="LocationsRowDeleted" msprop:Generator_RowEvArgName="LocationsRowChangeEvent" msprop:Generator_RowChangedName="LocationsRowChanged" msprop:Generator_RowClassName="LocationsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" minOccurs="0" />
              <xs:element name="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID" type="xs:int" minOccurs="0" />
              <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KeyPhrase" msprop:Generator_ColumnVarNameInTable="columnKeyPhrase" msprop:Generator_ColumnPropNameInRow="KeyPhrase" msprop:Generator_ColumnPropNameInTable="KeyPhraseColumn" msprop:Generator_UserColumnName="KeyPhrase" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DomainName" msprop:Generator_ColumnVarNameInTable="columnDomainName" msprop:Generator_ColumnPropNameInRow="DomainName" msprop:Generator_ColumnPropNameInTable="DomainNameColumn" msprop:Generator_UserColumnName="DomainName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PageTitle" msprop:Generator_ColumnVarNameInTable="columnPageTitle" msprop:Generator_ColumnPropNameInRow="PageTitle" msprop:Generator_ColumnPropNameInTable="PageTitleColumn" msprop:Generator_UserColumnName="PageTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PageDescript" msprop:Generator_ColumnVarNameInTable="columnPageDescript" msprop:Generator_ColumnPropNameInRow="PageDescript" msprop:Generator_ColumnPropNameInTable="PageDescriptColumn" msprop:Generator_UserColumnName="PageDescript" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Street" msprop:Generator_ColumnVarNameInTable="columnStreet" msprop:Generator_ColumnPropNameInRow="Street" msprop:Generator_ColumnPropNameInTable="StreetColumn" msprop:Generator_UserColumnName="Street" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Zip" msprop:Generator_ColumnVarNameInTable="columnZip" msprop:Generator_ColumnPropNameInRow="Zip" msprop:Generator_ColumnPropNameInTable="ZipColumn" msprop:Generator_UserColumnName="Zip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CustWebsite" msprop:Generator_ColumnVarNameInTable="columnCustWebsite" msprop:Generator_ColumnPropNameInRow="CustWebsite" msprop:Generator_ColumnPropNameInTable="CustWebsiteColumn" msprop:Generator_UserColumnName="CustWebsite" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyName" msprop:Generator_ColumnVarNameInTable="columnCompanyName" msprop:Generator_ColumnPropNameInRow="CompanyName" msprop:Generator_ColumnPropNameInTable="CompanyNameColumn" msprop:Generator_UserColumnName="CompanyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" msprop:Generator_UserColumnName="StartDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Terms" msprop:Generator_ColumnVarNameInTable="columnTerms" msprop:Generator_ColumnPropNameInRow="Terms" msprop:Generator_ColumnPropNameInTable="TermsColumn" msprop:Generator_UserColumnName="Terms" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnPropNameInTable="NotesColumn" msprop:Generator_UserColumnName="Notes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UID" msprop:Generator_ColumnVarNameInTable="columnUID" msprop:Generator_ColumnPropNameInRow="UID" msprop:Generator_ColumnPropNameInTable="UIDColumn" msprop:Generator_UserColumnName="UID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Images" msprop:Generator_TableClassName="ImagesDataTable" msprop:Generator_TableVarName="tableImages" msprop:Generator_TablePropName="Images" msprop:Generator_RowDeletingName="ImagesRowDeleting" msprop:Generator_UserTableName="Images" msprop:Generator_RowChangingName="ImagesRowChanging" msprop:Generator_RowEvHandlerName="ImagesRowChangeEventHandler" msprop:Generator_RowDeletedName="ImagesRowDeleted" msprop:Generator_RowEvArgName="ImagesRowChangeEvent" msprop:Generator_RowChangedName="ImagesRowChanged" msprop:Generator_RowClassName="ImagesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Image1" msprop:Generator_ColumnVarNameInTable="columnImage1" msprop:Generator_ColumnPropNameInRow="Image1" msprop:Generator_ColumnPropNameInTable="Image1Column" msprop:Generator_UserColumnName="Image1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image1Data" msprop:Generator_ColumnVarNameInTable="columnImage1Data" msprop:Generator_ColumnPropNameInRow="Image1Data" msprop:Generator_ColumnPropNameInTable="Image1DataColumn" msprop:Generator_UserColumnName="Image1Data" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image2" msprop:Generator_ColumnVarNameInTable="columnImage2" msprop:Generator_ColumnPropNameInRow="Image2" msprop:Generator_ColumnPropNameInTable="Image2Column" msprop:Generator_UserColumnName="Image2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image2Data" msprop:Generator_ColumnVarNameInTable="columnImage2Data" msprop:Generator_ColumnPropNameInRow="Image2Data" msprop:Generator_ColumnPropNameInTable="Image2DataColumn" msprop:Generator_UserColumnName="Image2Data" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image3" msprop:Generator_ColumnVarNameInTable="columnImage3" msprop:Generator_ColumnPropNameInRow="Image3" msprop:Generator_ColumnPropNameInTable="Image3Column" msprop:Generator_UserColumnName="Image3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image3Data" msprop:Generator_ColumnVarNameInTable="columnImage3Data" msprop:Generator_ColumnPropNameInRow="Image3Data" msprop:Generator_ColumnPropNameInTable="Image3DataColumn" msprop:Generator_UserColumnName="Image3Data" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image4" msprop:Generator_ColumnVarNameInTable="columnImage4" msprop:Generator_ColumnPropNameInRow="Image4" msprop:Generator_ColumnPropNameInTable="Image4Column" msprop:Generator_UserColumnName="Image4" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image4Data" msprop:Generator_ColumnVarNameInTable="columnImage4Data" msprop:Generator_ColumnPropNameInRow="Image4Data" msprop:Generator_ColumnPropNameInTable="Image4DataColumn" msprop:Generator_UserColumnName="Image4Data" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image5" msprop:Generator_ColumnVarNameInTable="columnImage5" msprop:Generator_ColumnPropNameInRow="Image5" msprop:Generator_ColumnPropNameInTable="Image5Column" msprop:Generator_UserColumnName="Image5" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image5Data" msprop:Generator_ColumnVarNameInTable="columnImage5Data" msprop:Generator_ColumnPropNameInRow="Image5Data" msprop:Generator_ColumnPropNameInTable="Image5DataColumn" msprop:Generator_UserColumnName="Image5Data" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image6" msprop:Generator_ColumnVarNameInTable="columnImage6" msprop:Generator_ColumnPropNameInRow="Image6" msprop:Generator_ColumnPropNameInTable="Image6Column" msprop:Generator_UserColumnName="Image6" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image6Data" msprop:Generator_ColumnVarNameInTable="columnImage6Data" msprop:Generator_ColumnPropNameInRow="Image6Data" msprop:Generator_ColumnPropNameInTable="Image6DataColumn" msprop:Generator_UserColumnName="Image6Data" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LocationsUID" msprop:Generator_ColumnVarNameInTable="columnLocationsUID" msprop:Generator_ColumnPropNameInRow="LocationsUID" msprop:Generator_ColumnPropNameInTable="LocationsUIDColumn" msprop:Generator_UserColumnName="LocationsUID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ImageLocation" msprop:Generator_ColumnVarNameInTable="columnImageLocation" msprop:Generator_ColumnPropNameInRow="ImageLocation" msprop:Generator_ColumnPropNameInTable="ImageLocationColumn" msprop:Generator_UserColumnName="ImageLocation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ImageData" msprop:Generator_ColumnVarNameInTable="columnImageData" msprop:Generator_ColumnPropNameInRow="ImageData" msprop:Generator_ColumnPropNameInTable="ImageDataColumn" msprop:Generator_UserColumnName="ImageData" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Reasons" msprop:Generator_TableClassName="ReasonsDataTable" msprop:Generator_TableVarName="tableReasons" msprop:Generator_TablePropName="Reasons" msprop:Generator_RowDeletingName="ReasonsRowDeleting" msprop:Generator_UserTableName="Reasons" msprop:Generator_RowChangingName="ReasonsRowChanging" msprop:Generator_RowEvHandlerName="ReasonsRowChangeEventHandler" msprop:Generator_RowDeletedName="ReasonsRowDeleted" msprop:Generator_RowEvArgName="ReasonsRowChangeEvent" msprop:Generator_RowChangedName="ReasonsRowChanged" msprop:Generator_RowClassName="ReasonsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Reason1" msprop:Generator_ColumnVarNameInTable="columnReason1" msprop:Generator_ColumnPropNameInRow="Reason1" msprop:Generator_ColumnPropNameInTable="Reason1Column" msprop:Generator_UserColumnName="Reason1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reason2" msprop:Generator_ColumnVarNameInTable="columnReason2" msprop:Generator_ColumnPropNameInRow="Reason2" msprop:Generator_ColumnPropNameInTable="Reason2Column" msprop:Generator_UserColumnName="Reason2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reason3" msprop:Generator_ColumnVarNameInTable="columnReason3" msprop:Generator_ColumnPropNameInRow="Reason3" msprop:Generator_ColumnPropNameInTable="Reason3Column" msprop:Generator_UserColumnName="Reason3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reason4" msprop:Generator_ColumnVarNameInTable="columnReason4" msprop:Generator_ColumnPropNameInRow="Reason4" msprop:Generator_ColumnPropNameInTable="Reason4Column" msprop:Generator_UserColumnName="Reason4" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reason5" msprop:Generator_ColumnVarNameInTable="columnReason5" msprop:Generator_ColumnPropNameInRow="Reason5" msprop:Generator_ColumnPropNameInTable="Reason5Column" msprop:Generator_UserColumnName="Reason5" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reason6" msprop:Generator_ColumnVarNameInTable="columnReason6" msprop:Generator_ColumnPropNameInRow="Reason6" msprop:Generator_ColumnPropNameInTable="Reason6Column" msprop:Generator_UserColumnName="Reason6" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LocationsUID" msprop:Generator_ColumnVarNameInTable="columnLocationsUID" msprop:Generator_ColumnPropNameInRow="LocationsUID" msprop:Generator_ColumnPropNameInTable="LocationsUIDColumn" msprop:Generator_UserColumnName="LocationsUID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Coupons" msprop:Generator_TableClassName="CouponsDataTable" msprop:Generator_TableVarName="tableCoupons" msprop:Generator_TablePropName="Coupons" msprop:Generator_RowDeletingName="CouponsRowDeleting" msprop:Generator_UserTableName="Coupons" msprop:Generator_RowChangingName="CouponsRowChanging" msprop:Generator_RowEvHandlerName="CouponsRowChangeEventHandler" msprop:Generator_RowDeletedName="CouponsRowDeleted" msprop:Generator_RowEvArgName="CouponsRowChangeEvent" msprop:Generator_RowChangedName="CouponsRowChanged" msprop:Generator_RowClassName="CouponsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="LocationsUID" msprop:Generator_ColumnVarNameInTable="columnLocationsUID" msprop:Generator_ColumnPropNameInRow="LocationsUID" msprop:Generator_ColumnPropNameInTable="LocationsUIDColumn" msprop:Generator_UserColumnName="LocationsUID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Headline" msprop:Generator_ColumnVarNameInTable="columnHeadline" msprop:Generator_ColumnPropNameInRow="Headline" msprop:Generator_ColumnPropNameInTable="HeadlineColumn" msprop:Generator_UserColumnName="Headline" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SubHeadline" msprop:Generator_ColumnVarNameInTable="columnSubHeadline" msprop:Generator_ColumnPropNameInRow="SubHeadline" msprop:Generator_ColumnPropNameInTable="SubHeadlineColumn" msprop:Generator_UserColumnName="SubHeadline" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_UserColumnName="Color" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Printable" msprop:Generator_ColumnVarNameInTable="columnPrintable" msprop:Generator_ColumnPropNameInRow="Printable" msprop:Generator_ColumnPropNameInTable="PrintableColumn" msprop:Generator_UserColumnName="Printable" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customer" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Locations" />
      <xs:field xpath="mstns:UID" />
    </xs:unique>
    <xs:unique name="Images_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Images" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Reasons_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Reasons" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Coupons_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Coupons" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:keyref name="FK_Customer_Locations" refer="Constraint1" msprop:rel_Generator_UserChildTable="Locations" msprop:rel_Generator_ChildPropName="GetLocationsRowsByFK_Customer_Locations" msprop:rel_Generator_ParentPropName="CustomerRowByFK_Customer_Locations" msprop:rel_Generator_UserRelationName="FK_Customer_Locations" msprop:rel_Generator_RelationVarName="relationFK_Customer_Locations" msprop:rel_Generator_UserParentTable="Customer">
      <xs:selector xpath=".//mstns:Locations" />
      <xs:field xpath="mstns:ID" />
    </xs:keyref>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="LocationsImages" msdata:parent="Locations" msdata:child="Images" msdata:parentkey="UID" msdata:childkey="LocationsUID" msprop:Generator_UserChildTable="Images" msprop:Generator_ChildPropName="GetImagesRows" msprop:Generator_ParentPropName="LocationsRow" msprop:Generator_UserRelationName="LocationsImages" msprop:Generator_RelationVarName="relationLocationsImages" msprop:Generator_UserParentTable="Locations" />
      <msdata:Relationship name="LocationsReasons" msdata:parent="Locations" msdata:child="Reasons" msdata:parentkey="UID" msdata:childkey="LocationsUID" msprop:Generator_UserChildTable="Reasons" msprop:Generator_ChildPropName="GetReasonsRows" msprop:Generator_ParentPropName="LocationsRow" msprop:Generator_UserRelationName="LocationsReasons" msprop:Generator_RelationVarName="relationLocationsReasons" msprop:Generator_UserParentTable="Locations" />
      <msdata:Relationship name="CustomerLocations" msdata:parent="Customer" msdata:child="Locations" msdata:parentkey="ID" msdata:childkey="CustomerID" msprop:Generator_UserChildTable="Locations" msprop:Generator_ChildPropName="GetLocationsRowsByCustomerLocations" msprop:Generator_ParentPropName="CustomerRowByCustomerLocations" msprop:Generator_UserRelationName="CustomerLocations" msprop:Generator_RelationVarName="relationCustomerLocations" msprop:Generator_UserParentTable="Customer" />
      <msdata:Relationship name="LocationsCoupons" msdata:parent="Locations" msdata:child="Coupons" msdata:parentkey="UID" msdata:childkey="LocationsUID" msprop:Generator_UserChildTable="Coupons" msprop:Generator_ChildPropName="GetCouponsRows" msprop:Generator_UserParentTable="Locations" msprop:Generator_UserRelationName="LocationsCoupons" msprop:Generator_RelationVarName="relationLocationsCoupons" msprop:Generator_ParentPropName="LocationsRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>